longops2.sql
prompt  where remain > 0 :
select sid
      ,username
      ,to_char(start_time,'hh24:mi') strt
      ,sofar
      ,totalwork
      ,elapsed_seconds
      ,time_remaining
      ,units
      ,OPname
from  V$SESSION_LONGOPS
where time_remaining  > 0
order by time_remaining
/